package com.cyf.db.mapper;

import com.cyf.db.bean.LocalManageAccount;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

import java.util.List;

/**
 * 查询
 * Created by asus on 2018/7/26.
 */

@Mapper
public interface LocalManageAccountMapper {

    /**
     * 检查该用户是否是上传/入录进来的数据
     */
    @Select("select m.*,p.`name` as parkingName from local_manageaccount m " +
            "left JOIN local_parking p on p.parkingId=m.parkingId  " +
            "where m.phone=#{phone} and m.status=1  ")
    List<LocalManageAccount> getManageAccountByPhone(@Param("phone") String phone);

}
